由 macro 发布于: 2001-03-03 07:41

用SYS，SYSTEM用户查看：

select SYSDATE-logon_time "Days", (SYSDATE-logon_time)*24 "Hours"
from sys.v_$session
where sid=1 /* this is PMON */


Days Hours
---------- ----------
15.8807639 381.138333